
project , uses(../data_output/legislators_klarner.dta)


	**********
	** ARIZONA - upper+lower
	** Consecutive term limites: 4 x 2-year terms.
	** First year: 2000	
	**********	
	
	use ../data_output/legislators_klarner.dta, clear
	gen lastname = regexs(1) if regexm(lower(CandName),"([^,]+)")
	gen firstname = regexs(1) if regexm(lower(CandName),",( [^ ]+)")
	gen mergename = trim(firstname +" " + lastname)
	keep if state=="AZ" 
	keep if regexm(term, "1991|1993|1995|1997|1999|2001|2003|2005|2007|2009|2011|2013|2015")
	drop lastname firstname
	replace mergename = "jack jackson jr." if CandName=="JACKSON, JACK C. JR." & year==2002
	save ../data_output/legislators_AZ_1991_2016.dta, replace
	
	gen year_minus0 = year	
	gen year_minus2 = year-2
	gen year_minus4 = year-4
	gen year_minus6 = year-6
	tostring year_minus*, replace
	gen s = year_minus6+";" +year_minus4+";"+year_minus2+";"+ year_minus0 + ";"
	gen termlimited = regexm(elections_won, s)==1 & year>=1998	
	save ../data_output/legislators_AZ_1991_2016.dta, replace
project , creates("../data_output/legislators_AZ_1991_2016.dta")	
	
project, original(../data_input/AZ/az_bills.csv)
	
	import delimited using ../data_input/AZ/az_bills.csv,  clear  delimiters(";") bindquotes(strict) encoding("utf-8")
	gen term = ""
	replace term = "1991-1992" if regexm(session, "1991|1992")
	replace term = "1993-1994" if regexm(session, "1993|1994")
	replace term = "1995-1996" if regexm(session, "1995|1996")	
	replace term = "1997-1998" if regexm(session, "1997|1998")
	replace term = "1999-2000" if regexm(session, "1999|2000")
	replace term = "2001-2002" if regexm(session, "2001|2002")
	replace term = "2003-2004" if regexm(session, "2003|2004")
	replace term = "2005-2006" if regexm(session, "2005|2006")
	replace term = "2007-2008" if regexm(session, "2007|2008")
	replace term = "2009-2010" if regexm(session, "2009|2010")
	replace term = "2011-2012" if regexm(session, "2011|2012")
	replace term = "2013-2014" if regexm(session, "2013|2014")
	replace term = "2015-2016" if regexm(session, "2015|2016")
	drop if term=="" // 2017 observations
	gen firstname = regexs(1) if regexm(lower(sponsor),"^([^, ]+)")
	gen lastname  = regexs(1) if regexm(lower(sponsor)," ([^, ]+)$")
	gen mergename = trim(firstname +" " + lastname)
	replace mergename = usubinstr(mergename, "ñ","n",.)
	replace mergename = usubinstr(mergename, "ó","o",.)
	replace mergename = "dave bradley" if mergename=="david bradley"
	replace mergename = "debbie mccunedavis" if mergename=="debbie mccune-davis"
	replace mergename = "debbie mccunedavis" if mergename=="debbie davis"
	replace mergename = "edward ableser" if mergename=="ed ableser"
	replace mergename = "james weiers" if mergename=="jim weiers"  & regexm(term, "2003")==0
	replace mergename = "kate brophymcgee" if mergename=="kate mcgee"
	replace mergename = "olivia cajerobedford" if mergename=="olivia bedford"
	replace mergename = "leah landrum" if mergename=="leah taylor" & regexm(term, "1999")==0
	replace mergename = "meg burtoncahill" if mergename=="meg cahill"
	replace mergename = "wesley marsh" if mergename=="wes marsh"
	replace mergename = "tom ohalleran" if mergename=="tom o'halleran"
	replace mergename = "louann preble" if mergename=="lou-ann preble"
	replace mergename = "tim bee" if mergename=="timothy bee"
	replace mergename = "ray barnes" if mergename=="rhonda barnes"
	replace mergename = "michelle ugenti" if mergename=="michelle ugenti-rita"
	replace mergename = "j. mesnard" if mergename=="javan mesnard"
	replace mergename = "peter rios" if mergename=="pete rios"
	replace mergename = "winifred hershberger" if mergename=="freddy hershberger" & regexm(term, "1995|1997")
	replace mergename = "pete hershberger" if mergename=="j. hershberger" & regexm(term, "2001")
	replace mergename = "manuel pena" if mergename=="manual jr." | mergename=="manuel jr."
	replace mergename = "ken cheuvront" if mergename=="kenneth cheuvront" & regexm(term, "1997|1999|2001")
	replace mergename = "phil hanson" if mergename=="philip hanson"
	replace mergename = "tom patterson" if mergename=="thomas patterson"
	replace mergename = "jack brown" if mergename=="j brown"
	replace mergename = "jeff hatchmiller" if mergename=="jeff hatch-miller"
	replace mergename = "austin turner" if mergename=="warren turner"
	replace mergename = "jan brewer" if mergename=="janice brewer"
	replace mergename = "jake flake" if mergename=="franklin flake"
	replace mergename = "david peterson" if mergename=="david petersen"
	replace mergename = "steve yarbrough" if mergename=="steven yarbrough"
	replace mergename = "james meredith" if mergename=="jim meredith"
	replace mergename = "stephen tully" if mergename=="steve tully"
	replace mergename = "jim hartdegan" if mergename=="jim hartdegen"
	replace mergename = "armando ruiz" if mergename=="armondo ruiz"
	replace mergename = "linda lopez" if mergename=="linda j.lopez"
	replace mergename = "bob robson" if mergename=="robert robson"
	replace mergename = "donald kenney" if mergename=="don kenney"
	replace mergename = "harry mitchell" if mergename=="hannah mitchell"
	replace mergename = "john ackerley" if mergename=="j. ackerley"
	replace mergename = "p. arredondo" if mergename=="ben arredondo"
	replace mergename = "patricia wright" if mergename=="pat wright"
	replace mergename = "karen willis" if mergename=="karen mills"
		
	merge m:1  mergename term  using ../data_output/legislators_AZ_1991_2016.dta
	*16 legislators do not appear in the master data: 2003-2004	bill wagner;2015-2016	ceci velasquez;2007-2008	cloves campbell;2009-2010	cloves campbell;1991-1992	earl wilcox;2003-2004	herb guenther;2003-2004	jack jackson;2003-2004	jack jackson jr.;1991-1992	james henderson;1997-1998	james henderson;2001-2002	mark osterloh;1993-1994	nancy wessel;1997-1998	ned king;1997-1998	paul mortensen;2003-2004	ramon valadez;2009-2010	steve gallardo
	
	drop sponsor
	gen sponsor = 1 if bill!="" &  regexm(type, "Prime")
	gen cosponsor = 1 if bill!="" &  regexm(type, "Co-")
	gen law = chapter!=.	& sponsor==1	
	drop if _merge==1
	save ../data_output/bills_by_sponsor_AZ_1991_2016.dta, replace
project , creates(../data_output/bills_by_sponsor_AZ_1991_2016.dta)


	use ../data_output/bills_by_sponsor_AZ_1991_2016.dta
	collapse (sum) cosponsor sponsor law (first) elections_* terms_in_office win TermLengthActual CandName district chamber state party mergename inoffice year termlimited vtsh, by(CandId term )
	
	save ../data_output/total_bills_by_sponsor_AZ_1991_2016.dta, replace
project , creates(../data_output/total_bills_by_sponsor_AZ_1991_2016.dta)
	

	
	*voting
	use ../data_output/legislators_klarner.dta, clear
	gen lastname = regexs(1) if regexm(lower(CandName),"([^,]+), [^!]")
	gen firstletter = regexs(1) if regexm(lower(CandName),"[^,]+, ([^!])")
	gen secondletter = regexs(1) if regexm(lower(CandName),"[^,]+, ([^!][^!])")
	keep if state=="AZ" 
	keep if regexm(term, "1991|1993|1995|1997|1999|2001|2003|2005|2007|2009|2011|2013|2015")
	gen os_mergename = lastname
	bys  os_mergename term: gen n = _n
	by  os_mergename term: egen mean_n=mean(n)
	replace os_mergename = lastname + " " + firstletter if mean_n>1  //firstname  + " " +  lastname //firstname+ ". "
	drop n mean_n
	replace os_mergename = "jack jackson jr." if CandName=="JACKSON, JACK C. JR." & year==2002	
	bys  os_mergename term: gen n = _n
	by  os_mergename term: egen mean_n=mean(n)
	replace os_mergename = lastname + " " + firstletter+secondletter if mean_n>1  //firstname  + " " +  lastname //firstname+ ". "
	drop n mean_n
	tempfile tmp
	save `tmp', replace
	

project , original(../data_input/AZ/az_votes.csv)	
	import delimited using ../data_input/AZ/az_votes.csv,  clear  delimiters(";") bindquotes(strict) encoding("utf-8") varnames(1)
	gen term = ""
	replace term = "1991-1992" if regexm(session, "1991|1992")
	replace term = "1993-1994" if regexm(session, "1993|1994")
	replace term = "1995-1996" if regexm(session, "1995|1996")	
	replace term = "1997-1998" if regexm(session, "1997|1998")
	replace term = "1999-2000" if regexm(session, "1999|2000")
	replace term = "2001-2002" if regexm(session, "2001|2002")
	replace term = "2003-2004" if regexm(session, "2003|2004")
	replace term = "2005-2006" if regexm(session, "2005|2006")
	replace term = "2007-2008" if regexm(session, "2007|2008")
	replace term = "2009-2010" if regexm(session, "2009|2010")
	replace term = "2011-2012" if regexm(session, "2011|2012")
	replace term = "2013-2014" if regexm(session, "2013|2014")
	replace term = "2015-2016" if regexm(session, "2015|2016")
	gen chamber = ""
	replace chamber = "house" if regexm(lower(location), "house")
	replace chamber = "senate" if regexm(lower(location), "senate")
	gen os_mergename = lower(name)
	replace os_mergename = lower(os_mergename)
	replace os_mergename = subinstr(os_mergename,"’","",.)
	replace os_mergename = subinstr(os_mergename,"'","",.)
	replace os_mergename = subinstr(os_mergename,"-","",.)	
	replace os_mergename = "hartdegan"	if os_mergename=="hartdegen" & regexm(term, "1991")
	replace os_mergename = "peterson"	if os_mergename=="petersen" & regexm(term, "1995|1997|1999|2001")
	replace os_mergename = "rios r"	if os_mergename=="rios" & regexm(term, "1999|2007")
	replace os_mergename = "burtoncahill"	if os_mergename=="burton cahill" & regexm(term, "2001|2003|2005|2007|2009")
	replace os_mergename = "landrum"	if os_mergename=="landrum taylor" & regexm(term, "2001|2003|2005|2007|2009|2011|2013")
	replace os_mergename = "jarrett"	if os_mergename=="jarrett m" & regexm(term, "2001")
	replace os_mergename = "cajerobedford"	if os_mergename=="cajero bedford" & regexm(term, "2003|2005|2007|2009|2011|2013|2015")
	replace os_mergename = "cannell"	if os_mergename=="cannell r" & regexm(term, "2003")
	replace os_mergename = "jack jackson jr." 	if os_mergename=="jackson, jr" & regexm(term, "2003")
	replace os_mergename = "jackson j" 	if os_mergename=="jackson sr." & regexm(term, "2003")
	replace os_mergename = "lopez"	if os_mergename=="lopez l" & regexm(term, "2003")
	replace os_mergename = "mccunedavis"	if os_mergename=="mccune davis" & regexm(term, "2003|2005|2007|2009|2011|2013|2015")
	replace os_mergename = "soltero"	if os_mergename=="soltero v" & regexm(term, "2003")
	replace os_mergename = "weiers jje" if os_mergename=="weiers j"  & regexm(term, "2005|2007|2009|2011")
	replace os_mergename = "weiers jja"	if os_mergename=="weiers jp" & regexm(term, "2005|2007|2009|2011")
	replace os_mergename = "campbell ccl"	if os_mergename=="campbell cl" & regexm(term, "2007|2009")
	replace os_mergename = "campbell cch"	if os_mergename=="campbell ch" & regexm(term, "2007|2009")
	replace os_mergename = "garcia j"	if os_mergename=="garcia" & regexm(term, "2007|2009")
	replace os_mergename = "miranda r"	if os_mergename=="miranda" & regexm(term, "2007|2009")
	replace os_mergename = "burns r"	if os_mergename=="burns" & regexm(term, "2007")
	replace os_mergename = "allen"	if [os_mergename=="allen c" | os_mergename=="allen s"] & regexm(term, "2007")
	replace os_mergename = "allen c"	if os_mergename=="allen"  & regexm(term, "2009")
	replace os_mergename = "pearce"	if os_mergename=="pearce r"  & regexm(term, "2009|2011")
	replace os_mergename = "pierce"	if os_mergename=="pierce s"  & regexm(term, "2009|2011")
	replace os_mergename = "wright"	if os_mergename=="young wright"  & regexm(term, "2009")
	replace os_mergename = "gray l"	if os_mergename=="gray"  & regexm(term, "2011")
	replace os_mergename = "brophymcgee"	if os_mergename=="brophy mcgee"  & regexm(term, "2011|2013|2015")
	replace os_mergename = "smith s"	if os_mergename=="smith"  & regexm(term, "2011")
	replace os_mergename = "pierce s"	if os_mergename=="pierce"  & regexm(term, "2013")
	replace os_mergename = "ugenti"	if os_mergename=="ugentirita"  & regexm(term, "2015")
		
	merge m:1  os_mergename term using `tmp'
	
	// obs not merging
	drop if _merge==1
	drop _merge
	gen floorvotes = 0 
	replace floorvotes=1 if regexm(lower(vote), "yes|no") 
	replace vote = "1" if lower(vote)=="yes"
	replace vote = "-1" if lower(vote)=="no"
	replace vote = "0" if vote!="1" & vote!="-1"
	destring vote, replace
	egen vote_id = group( floor chamber term bill date location)
	bys party vote_id : egen party_mean=mean(vote)
	gen party_vote = 0
	replace party_vote = 1 if party_mean>0
	replace party_vote = -1 if party_mean<0
	gen vote_party_line = vote==party_vote
	gen vote_against_party = vote==-party_vote
	bys vote_id: egen votemargin = mean(vote)
	gen close_floorvotes = floorvotes if abs(votemargin)<.1	
	
	save ../data_output/floorvotes_AZ_1991_2016.dta, replace	
project , creates(../data_output/floorvotes_AZ_1991_2016.dta)	

	use ../data_output/floorvotes_AZ_1991_2016.dta, clear
	collapse  (mean) vote_party_line vote_against_party (sum) close_floorvotes floorvotes (first) elections_* terms_in_office win TermLengthActual CandName district chamber state party  inoffice year  vtsh, by(CandId term )
	save ../data_output/total_floorvotes_AZ_1991_2016.dta, replace
project , creates(../data_output/total_floorvotes_AZ_1991_2016.dta)	
	

	
	**CMT voting
	use ../data_output/legislators_klarner.dta, clear
	gen lastname = regexs(1) if regexm(lower(CandName),"([^,]+), [^!]")
	gen firstname = regexs(1) if regexm(lower(CandName),"[^,]+, ([^ ]+)")
	keep if state=="AZ" 
	keep if regexm(term, "1991|1993|1995|1997|1999|2001|2003|2005|2007|2009|2011|2013|2015")
	gen os_mergename = firstname  + " " + lastname
	replace os_mergename = "jack jackson jr." if CandName=="JACKSON, JACK C. JR." & year==2002	
	tempfile tmp
	save `tmp', replace
	

project, original(../data_input/AZ/az_cmtvotes.csv)
	import delimited using ../data_input/AZ/az_cmtvotes.csv,  clear  delimiters(";") bindquotes(strict) encoding("utf-8") varnames(1)
	gen term = ""
	replace term = "1991-1992" if regexm(session, "1991|1992")
	replace term = "1993-1994" if regexm(session, "1993|1994")
	replace term = "1995-1996" if regexm(session, "1995|1996")	
	replace term = "1997-1998" if regexm(session, "1997|1998")
	replace term = "1999-2000" if regexm(session, "1999|2000")
	replace term = "2001-2002" if regexm(session, "2001|2002")
	replace term = "2003-2004" if regexm(session, "2003|2004")
	replace term = "2005-2006" if regexm(session, "2005|2006")
	replace term = "2007-2008" if regexm(session, "2007|2008")
	replace term = "2009-2010" if regexm(session, "2009|2010")
	replace term = "2011-2012" if regexm(session, "2011|2012")
	replace term = "2013-2014" if regexm(session, "2013|2014")
	replace term = "2015-2016" if regexm(session, "2015|2016")
	replace chamber = "house" if regexm(lower(location), "house")
	replace chamber = "senate" if regexm(lower(location), "senate")
	gen os_mergename = lower(name)
	replace os_mergename = lower(os_mergename)
	replace os_mergename = subinstr(os_mergename,`"""',"",.)
	replace os_mergename = subinstr(os_mergename,"’","",.)
	replace os_mergename = subinstr(os_mergename,"'","",.)
	replace os_mergename = subinstr(os_mergename,"-","",.)	
	replace os_mergename = subinstr(os_mergename,",","",.)	
	replace os_mergename = "armando ruiz"	if os_mergename=="armondo ruiz" & regexm(term, "1991")
	replace os_mergename = "a. hardt"	if os_mergename=="a. bill hardt" & regexm(term, "1991|1993|1995")
	replace os_mergename = "donald kenney"	if os_mergename=="don kenney" & regexm(term, "1991")
	replace os_mergename = "james meredith"	if os_mergename=="jim meredith" & regexm(term, "1991")
	replace os_mergename = "jim hartdegan"	if os_mergename=="jim hartdegen" & regexm(term, "1991")
	replace os_mergename = "patricia wright"	if os_mergename=="pat wright" & regexm(term, "1991")
	replace os_mergename = "manuel pena"	if os_mergename=="manual jr." & regexm(term, "1991")
	replace os_mergename = "karen willis"	if os_mergename=="karen mills" & regexm(term, "1991")
	replace os_mergename = "james henderson"	if os_mergename=="james jr." & regexm(term, "1991|1997")
	replace os_mergename = "e. rosenbaum"	if os_mergename=="e. polly rosenbaum" & regexm(term, "1993")
	replace os_mergename = "jan brewer"	if os_mergename=="janice brewer" & regexm(term, "1993|1995")
	replace os_mergename = "manuel pena"	if os_mergename=="manuel pena jr." & regexm(term, "1993")
	replace os_mergename = "robert mclendon"	if os_mergename=="robert bob mclendon" & regexm(term, "1993|1995")
	replace os_mergename = "austin turner"	if os_mergename=="warren turner" & regexm(term, "1993|1995")
	replace os_mergename = "david peterson"	if os_mergename=="david petersen" & regexm(term, "1995|1997|1999|2001")
	replace os_mergename = "james weiers"	if os_mergename=="jim weiers" & regexm(term, "1995|1997|1999|2001|2005|2007|2011")
	replace os_mergename = "tom patterson"	if os_mergename=="thomas patterson" & regexm(term, "1995|1997")
	replace os_mergename = "wesley marsh"	if os_mergename=="wes marsh" & regexm(term, "1995|1997|1999|2001")
	replace os_mergename = "winifred hershberger"	if os_mergename=="freddy hershberger" & regexm(term, "1995|1997")
	replace os_mergename = "jake flake"	if os_mergename=="franklin jake flake" & regexm(term, "1995|1997")
	replace os_mergename = "ken cheuvront"	if os_mergename=="kenneth cheuvront" & regexm(term, "1997|1999|2001")
	replace os_mergename = "sally gonzales"	if os_mergename=="sally trujillo gonzales" & regexm(term, "1997|1999")
	replace os_mergename = "jake flake"	if os_mergename=="franklin (jake) flake" & regexm(term, "1999")
	replace os_mergename = "leah landrum"	if os_mergename=="leah taylor" & regexm(term, "2001|2003|2009|2011|2013")
	replace os_mergename = "linda lopez"	if os_mergename=="linda j.lopez" & regexm(term, "2001")
	replace os_mergename = "meg burtoncahill"	if os_mergename=="meg cahill" & regexm(term, "2001|2003|2005|2007|2009")
	replace os_mergename = "peter rios"	if os_mergename=="pete rios" & regexm(term, "2001|2003|2005|2007")
	replace os_mergename = "phil hanson"	if os_mergename=="philip hanson" & regexm(term, "2001|2003")
	replace os_mergename = "bob robson"	if os_mergename=="robert robson" & regexm(term, "2001")
	replace os_mergename = "stephen tully"	if os_mergename=="steve tully" & regexm(term, "2001")
	replace os_mergename = "tim bee"	if os_mergename=="timothy bee" & regexm(term, "2001|2003|2005|2007")
	replace os_mergename = "dave bradley"	if os_mergename=="david bradley" & regexm(term, "2003|2005|2007|2009|2011|2013|2015")
	replace os_mergename = "debbie mccunedavis"	if os_mergename=="debbie davis" & regexm(term, "2003|2007|2009")
	replace os_mergename = "jack jackson"	if os_mergename=="jack jackson sr." & regexm(term, "2003")
	replace os_mergename = "manuel alvarez"	if os_mergename=="manuel manny alvarez" & regexm(term, "2003|2005|2007|2009")
	replace os_mergename = "olivia cajerobedford"	if os_mergename=="olivia bedford" & regexm(term, "2003")
	replace os_mergename = "steve yarbrough"	if os_mergename=="steven yarbrough" & regexm(term, "2003")
	replace os_mergename = "bill wagner"	if os_mergename=="bill iii" & regexm(term, "2003")
	replace os_mergename = "debbie mccunedavis"	if os_mergename=="debbie mccune davis" & regexm(term, "2005|2011|2013|2015")
	replace os_mergename = "john allen"	if os_mergename=="john m. allen" & regexm(term, "2005|2013|2015")
	replace os_mergename = "leah landrum"	if os_mergename=="leah landrum taylor" & regexm(term, "2005|2007")
	replace os_mergename = "olivia cajerobedford"	if os_mergename=="olivia cajero bedford" & regexm(term, "2005|2007|2009|2011|2013|2015")
	replace os_mergename = "ray barnes"	if os_mergename=="rhonda barnes" & regexm(term, "2005|2007|2009")
	replace os_mergename = "jack brown"	if os_mergename=="j brown" & regexm(term, "2005|2007|2009")
	replace os_mergename = "harry mitchell"	if os_mergename=="hannah mitchell" & regexm(term, "2005")
	replace os_mergename = "cloves campbell"	if os_mergename=="cloves campbell jr." & regexm(term, "2007|2009")
	replace os_mergename = "edward ableser"	if os_mergename=="ed ableser" & regexm(term, "2007|2009|2011|2013|2015")
	replace os_mergename = "j. mesnard"	if os_mergename=="javan d. mesnard" & regexm(term, "2011|2013|2015")
	replace os_mergename = "kate brophymcgee"	if os_mergename=="kate brophy mcgee" & regexm(term, "2011|2013|2015")
	replace os_mergename = "michelle ugenti"	if os_mergename=="michelle ugentirita" & regexm(term, "2011|2013|2015")
	replace os_mergename = "sally gonzales"	if os_mergename=="sally ann gonzales" & regexm(term, "2011|2013|2015")
	replace os_mergename = "p. arredondo"	if os_mergename=="ben arredondo" & regexm(term, "2011")
	replace os_mergename = "charlene fernandez"	if os_mergename=="charlene r. fernandez" & regexm(term, "2015")
	replace os_mergename = "john ackerley"	if os_mergename=="j. christopher ackerley" & regexm(term, "2015")
		
	merge m:1   os_mergename term using `tmp'
	** 19 obs are not merging
	drop if _merge==1
	drop _merge
	gen cmtvotes = 0 
	replace cmtvotes=1 if regexm(lower(vote), "yes|no") 
	replace vote = "1" if lower(vote)=="yes"
	replace vote = "-1" if lower(vote)=="no"
	replace vote = "0" if vote!="1" & vote!="-1"
	destring vote, replace
	egen vote_id = group(  chamber term bill date location), missing
	bys party vote_id : egen party_mean=mean(vote)
	gen party_vote = 0
	replace party_vote = 1 if party_mean>0
	replace party_vote = -1 if party_mean<0
	gen vote_party_line = vote==party_vote
	gen vote_against_party = vote==-party_vote

	save ../data_output/cmtvotes_AZ_1991_2016.dta, replace	
project, creates(../data_output/cmtvotes_AZ_1991_2016.dta)
	
	use ../data_output/cmtvotes_AZ_1991_2016.dta, clear
	collapse  (mean) vote_party_line vote_against_party (sum) cmtvotes (first) elections_* terms_in_office win TermLengthActual CandName district chamber state party  inoffice year  vtsh, by(CandId term )
	save ../data_output/total_cmtvotes_AZ_1991_2016.dta, replace
project, creates(../data_output/total_cmtvotes_AZ_1991_2016.dta)
